use Den_Database
Insert Into Patient Values ('100', 'Cameron', 'Rees', 'Male', '10 Wimslow Drive', 'SA1 7JI', '20-01-21;, '01792 785624');
Insert Into Patient Values ('101', 'Sam', 'Walls', 'Male', '21 Dyfed Avenue', 'SA2 4QW', '21-01-21;, '01792 826301');
Insert Into Patient Values ('102', 'Skye', 'Jones', 'Female', '6 Brighton Road', 'SA4 8TY', '22-01-21;, '01792 092615');
Insert Into Patient Values ('103', 'Lewis', 'Blyth', 'Male', '82 Frogmore Drive', 'SA2 6GH', '22-01-21;, '01792 625381');
Insert Into Patient Values ('104', 'Kate', 'Smith', 'Female', '36 Tycoch Road', 'SA2 5DI', '20-01-21;, '01792 928749');
Insert Into Patient Values ('105', 'Morgan', 'Edwards', 'Male', '13 Claire Street', 'SA4 8KO', '23-01-21;, '01792 836391');

use Den_Database
Insert Into Receptionist Values ('001', '87 Stroude Road', 'Female', 'Madison Griffiths', '01792 826345');
Insert Into Receptionist Values ('002', '121 Redcliffe Way', 'Male', 'Jayden Payne', '01792 674932');
Insert Into Receptionist Values ('003', '81 Wern Ddu Lane', 'Female', 'Megan Sullivan', '01792 537302');
Insert Into Receptionist Values ('004', '107 Leicester Road', 'Male', 'Joe Wong', '01792 528392');
Insert Into Receptionist Values ('005', '58 Friar Street', 'Male', 'Ethan Thompson', '01792 263832');
Insert Into Receptionist Values ('006', '29 Academy Street', 'Male', 'Edward Palmer', '01792 373628');

use Den_Database
Insert Into Record Values ('10-02-21', '483921', 'Filling Teeth', '0101');
Insert Into Record Values ('10-02-21', '748302', 'Broken Tooth', '0102');
Insert Into Record Values ('11-02-21', '726282', 'Filling Teeth', '0103');
Insert Into Record Values ('12-02-21', '624821, 'Check-up', '0104');
Insert Into Record Values ('12-02-21', '638272', 'Broken Tooth', '0105');
Insert Into Record Values ('13-02-21', '629263', 'Check-up', '0106');

use Den_Database
Insert Into Room Values ('001', 'Big Room', '2 Hours');
Insert Into Room Values ('005', 'Small Room', '1 Hour');
Insert Into Room Values ('002', 'Medium Room', '2 Hours');
Insert Into Room Values ('001', 'Big Room', '1 Hour');
Insert Into Room Values ('004', 'Small Room', '1 Hour');
Insert Into Room Values ('003', 'Medium Room', '1 Hour');

use Den_Database
Insert Into Medicine Values ('020', £102.00, '4737281');
Insert Into Medicine Values ('012', £70.35, '7361836');
Insert Into Medicine Values ('001', £10.50, '8367272');
Insert Into Medicine Values ('060', £256.37, '7281961');
Insert Into Medicine Values ('023', £109.00, '6482726');
Insert Into Medicine Values ('011', £47.82, '1083726');

use Den_Database
Insert Into Nurse Values ('007', '23', '73 Old Edinburgh Road', 'Male', 'Jack Clayton', '01792 928372');
Insert Into Nurse Values ('008', '27', '65 Gloddaeth Street', 'Male', 'Evan Joyce', '01792 827272');
Insert Into Nurse Values ('009', '32', '106 Freezeland Lane', 'Male', 'Isaac Cameron', '01792 836374');

use Den_Database
Insert Into Dentist Values ('010', '35', '81 Dover Road', 'Female', 'Sienna Gough', '01792 538472');
Insert Into Dentist Values ('011', '40', '32 Wressle Road', 'Male', 'Thomas John', '01792 617537');
Insert Into Dentist Values ('012', '38', '69 Southend Avenue', 'Female', 'Rosie Hancock', '01792 526182');

use Den_Database
Insert Into Hygienists Values ('013', '35', '62 Shore Street', 'Male', 'Dylan Parsons', '01792 837281');
Insert Into Hygienists Values ('014', '36', '61 London Road', 'Female', 'Taylor Kirby', '01792 917368');
Insert Into Hygienists Values ('015', '29', '51 Cambridge Road', 'Male', 'Freddie Collins', '01792 547072');